Pasting OD matrix data into the spreadsheet

The first thing you need to do is specify whether the pedestrian data you are about to enter is expressed as percentages or as absolute numbers.

Tip: You can reference other workbooks and worksheets if you prefer, rather than paste data; see Excel documentation.

To paste OD matrix data into the spreadsheet:

In the cell labelled ‘Is the OD matrix specified in percentage?’, select Yes or No from the drop-down list.
If you choose ‘Yes’, the values you enter for each origin must add up to 100%.

If you choose ‘No’, enter the exact number of pedestrians.
Paste your column of origins into column B in the spreadsheet, underneath the heading ‘Origins’.
Paste the names of the destinations next to the label ‘Destinations’ and across columns E, F, G and so on.
Tip: To specify Entity choice for an OD value, enter c rather than an absolute number or percentage. For more information, see "A note on Entity Choice " in Different Entity Types/Supplies per origin .
Click in the cell beneath (next to ‘Colour’), click the 'Fill' icon on the toolbar and pick a colour from the palette (different versions of Excel may have different methods for changing the colour of cells)
Paste the appropriate values (numbers or percentages) into the cells where origins and destinations intersect.
In the cell immediately to the right of each origin name, select an Entity or Supply Type from the drop-down list.